/*
Navicat MySQL Data Transfer

Source Server         : connectToAccountm
Source Server Version : 50158
Source Host           : localhost:3306
Source Database       : accountm

Target Server Type    : MYSQL
Target Server Version : 50158
File Encoding         : 65001

Date: 2011-10-09 20:35:34
*/

SET FOREIGN_KEY_CHECKS=0;

-- ----------------------------
-- Table structure for `auth_group`
-- ----------------------------
DROP TABLE IF EXISTS `auth_group`;
CREATE TABLE `auth_group` (
`id`  int(11) NOT NULL AUTO_INCREMENT ,
`name`  varchar(80) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ,
PRIMARY KEY (`id`),
UNIQUE INDEX `name` USING BTREE (`name`) 
)
ENGINE=InnoDB
DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci
AUTO_INCREMENT=1

;

-- ----------------------------
-- Records of auth_group
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for `auth_group_permissions`
-- ----------------------------
DROP TABLE IF EXISTS `auth_group_permissions`;
CREATE TABLE `auth_group_permissions` (
`id`  int(11) NOT NULL AUTO_INCREMENT ,
`group_id`  int(11) NOT NULL ,
`permission_id`  int(11) NOT NULL ,
PRIMARY KEY (`id`),
FOREIGN KEY (`group_id`) REFERENCES `auth_group` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
FOREIGN KEY (`permission_id`) REFERENCES `auth_permission` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
UNIQUE INDEX `group_id` USING BTREE (`group_id`, `permission_id`) ,
INDEX `auth_group_permissions_425ae3c4` USING BTREE (`group_id`) ,
INDEX `auth_group_permissions_1e014c8f` USING BTREE (`permission_id`) 
)
ENGINE=InnoDB
DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci
AUTO_INCREMENT=1

;

-- ----------------------------
-- Records of auth_group_permissions
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for `auth_message`
-- ----------------------------
DROP TABLE IF EXISTS `auth_message`;
CREATE TABLE `auth_message` (
`id`  int(11) NOT NULL AUTO_INCREMENT ,
`user_id`  int(11) NOT NULL ,
`message`  longtext CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ,
PRIMARY KEY (`id`),
FOREIGN KEY (`user_id`) REFERENCES `auth_user` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
INDEX `auth_message_403f60f` USING BTREE (`user_id`) 
)
ENGINE=InnoDB
DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci
AUTO_INCREMENT=1

;

-- ----------------------------
-- Records of auth_message
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for `auth_permission`
-- ----------------------------
DROP TABLE IF EXISTS `auth_permission`;
CREATE TABLE `auth_permission` (
`id`  int(11) NOT NULL AUTO_INCREMENT ,
`name`  varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ,
`content_type_id`  int(11) NOT NULL ,
`codename`  varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ,
PRIMARY KEY (`id`),
FOREIGN KEY (`content_type_id`) REFERENCES `django_content_type` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
UNIQUE INDEX `content_type_id` USING BTREE (`content_type_id`, `codename`) ,
INDEX `auth_permission_1bb8f392` USING BTREE (`content_type_id`) 
)
ENGINE=InnoDB
DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci
AUTO_INCREMENT=37

;

-- ----------------------------
-- Records of auth_permission
-- ----------------------------
BEGIN;
INSERT INTO `auth_permission` VALUES ('1', 'Can add permission', '1', 'add_permission'), ('2', 'Can change permission', '1', 'change_permission'), ('3', 'Can delete permission', '1', 'delete_permission'), ('4', 'Can add group', '2', 'add_group'), ('5', 'Can change group', '2', 'change_group'), ('6', 'Can delete group', '2', 'delete_group'), ('7', 'Can add user', '3', 'add_user'), ('8', 'Can change user', '3', 'change_user'), ('9', 'Can delete user', '3', 'delete_user'), ('10', 'Can add message', '4', 'add_message'), ('11', 'Can change message', '4', 'change_message'), ('12', 'Can delete message', '4', 'delete_message'), ('13', 'Can add content type', '5', 'add_contenttype'), ('14', 'Can change content type', '5', 'change_contenttype'), ('15', 'Can delete content type', '5', 'delete_contenttype'), ('16', 'Can add session', '6', 'add_session'), ('17', 'Can change session', '6', 'change_session'), ('18', 'Can delete session', '6', 'delete_session'), ('19', 'Can add site', '7', 'add_site'), ('20', 'Can change site', '7', 'change_site'), ('21', 'Can delete site', '7', 'delete_site'), ('22', 'Can add pp case info', '8', 'add_ppcaseinfo'), ('23', 'Can change pp case info', '8', 'change_ppcaseinfo'), ('24', 'Can delete pp case info', '8', 'delete_ppcaseinfo'), ('25', 'Can add pp case investigation', '9', 'add_ppcaseinvestigation'), ('26', 'Can change pp case investigation', '9', 'change_ppcaseinvestigation'), ('27', 'Can delete pp case investigation', '9', 'delete_ppcaseinvestigation'), ('28', 'Can add pp case handle', '10', 'add_ppcasehandle'), ('29', 'Can change pp case handle', '10', 'change_ppcasehandle'), ('30', 'Can delete pp case handle', '10', 'delete_ppcasehandle'), ('31', 'Can add pp case refund', '11', 'add_ppcaserefund'), ('32', 'Can change pp case refund', '11', 'change_ppcaserefund'), ('33', 'Can delete pp case refund', '11', 'delete_ppcaserefund'), ('34', 'Can add log entry', '12', 'add_logentry'), ('35', 'Can change log entry', '12', 'change_logentry'), ('36', 'Can delete log entry', '12', 'delete_logentry');
COMMIT;

-- ----------------------------
-- Table structure for `auth_user`
-- ----------------------------
DROP TABLE IF EXISTS `auth_user`;
CREATE TABLE `auth_user` (
`id`  int(11) NOT NULL AUTO_INCREMENT ,
`username`  varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ,
`first_name`  varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ,
`last_name`  varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ,
`email`  varchar(75) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ,
`password`  varchar(128) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ,
`is_staff`  tinyint(1) NOT NULL ,
`is_active`  tinyint(1) NOT NULL ,
`is_superuser`  tinyint(1) NOT NULL ,
`last_login`  datetime NOT NULL ,
`date_joined`  datetime NOT NULL ,
PRIMARY KEY (`id`),
UNIQUE INDEX `username` USING BTREE (`username`) 
)
ENGINE=InnoDB
DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci
AUTO_INCREMENT=2

;

-- ----------------------------
-- Records of auth_user
-- ----------------------------
BEGIN;
INSERT INTO `auth_user` VALUES ('1', 'dino', '', '', 'wllbll.liu@gmail.com', 'sha1$89554$09883a225b787c637a930138e273ed1d43fe87d5', '1', '1', '1', '2011-10-09 18:20:30', '2011-10-09 11:20:57');
COMMIT;

-- ----------------------------
-- Table structure for `auth_user_groups`
-- ----------------------------
DROP TABLE IF EXISTS `auth_user_groups`;
CREATE TABLE `auth_user_groups` (
`id`  int(11) NOT NULL AUTO_INCREMENT ,
`user_id`  int(11) NOT NULL ,
`group_id`  int(11) NOT NULL ,
PRIMARY KEY (`id`),
FOREIGN KEY (`group_id`) REFERENCES `auth_group` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
FOREIGN KEY (`user_id`) REFERENCES `auth_user` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
UNIQUE INDEX `user_id` USING BTREE (`user_id`, `group_id`) ,
INDEX `auth_user_groups_403f60f` USING BTREE (`user_id`) ,
INDEX `auth_user_groups_425ae3c4` USING BTREE (`group_id`) 
)
ENGINE=InnoDB
DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci
AUTO_INCREMENT=1

;

-- ----------------------------
-- Records of auth_user_groups
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for `auth_user_user_permissions`
-- ----------------------------
DROP TABLE IF EXISTS `auth_user_user_permissions`;
CREATE TABLE `auth_user_user_permissions` (
`id`  int(11) NOT NULL AUTO_INCREMENT ,
`user_id`  int(11) NOT NULL ,
`permission_id`  int(11) NOT NULL ,
PRIMARY KEY (`id`),
FOREIGN KEY (`permission_id`) REFERENCES `auth_permission` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
FOREIGN KEY (`user_id`) REFERENCES `auth_user` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
UNIQUE INDEX `user_id` USING BTREE (`user_id`, `permission_id`) ,
INDEX `auth_user_user_permissions_403f60f` USING BTREE (`user_id`) ,
INDEX `auth_user_user_permissions_1e014c8f` USING BTREE (`permission_id`) 
)
ENGINE=InnoDB
DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci
AUTO_INCREMENT=1

;

-- ----------------------------
-- Records of auth_user_user_permissions
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for `django_admin_log`
-- ----------------------------
DROP TABLE IF EXISTS `django_admin_log`;
CREATE TABLE `django_admin_log` (
`id`  int(11) NOT NULL AUTO_INCREMENT ,
`action_time`  datetime NOT NULL ,
`user_id`  int(11) NOT NULL ,
`content_type_id`  int(11) NULL DEFAULT NULL ,
`object_id`  longtext CHARACTER SET utf8 COLLATE utf8_general_ci NULL ,
`object_repr`  varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ,
`action_flag`  smallint(5) UNSIGNED NOT NULL ,
`change_message`  longtext CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ,
PRIMARY KEY (`id`),
FOREIGN KEY (`content_type_id`) REFERENCES `django_content_type` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
FOREIGN KEY (`user_id`) REFERENCES `auth_user` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
INDEX `django_admin_log_403f60f` USING BTREE (`user_id`) ,
INDEX `django_admin_log_1bb8f392` USING BTREE (`content_type_id`) 
)
ENGINE=InnoDB
DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci
AUTO_INCREMENT=1

;

-- ----------------------------
-- Records of django_admin_log
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for `django_content_type`
-- ----------------------------
DROP TABLE IF EXISTS `django_content_type`;
CREATE TABLE `django_content_type` (
`id`  int(11) NOT NULL AUTO_INCREMENT ,
`name`  varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ,
`app_label`  varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ,
`model`  varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ,
PRIMARY KEY (`id`),
UNIQUE INDEX `app_label` USING BTREE (`app_label`, `model`) 
)
ENGINE=InnoDB
DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci
AUTO_INCREMENT=13

;

-- ----------------------------
-- Records of django_content_type
-- ----------------------------
BEGIN;
INSERT INTO `django_content_type` VALUES ('1', 'permission', 'auth', 'permission'), ('2', 'group', 'auth', 'group'), ('3', 'user', 'auth', 'user'), ('4', 'message', 'auth', 'message'), ('5', 'content type', 'contenttypes', 'contenttype'), ('6', 'session', 'sessions', 'session'), ('7', 'site', 'sites', 'site'), ('8', 'pp case info', 'pp_case', 'ppcaseinfo'), ('9', 'pp case investigation', 'pp_case', 'ppcaseinvestigation'), ('10', 'pp case handle', 'pp_case', 'ppcasehandle'), ('11', 'pp case refund', 'pp_case', 'ppcaserefund'), ('12', 'log entry', 'admin', 'logentry');
COMMIT;

-- ----------------------------
-- Table structure for `django_session`
-- ----------------------------
DROP TABLE IF EXISTS `django_session`;
CREATE TABLE `django_session` (
`session_key`  varchar(40) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ,
`session_data`  longtext CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ,
`expire_date`  datetime NOT NULL ,
PRIMARY KEY (`session_key`),
INDEX `django_session_3da3d3d8` USING BTREE (`expire_date`) 
)
ENGINE=InnoDB
DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci

;

-- ----------------------------
-- Records of django_session
-- ----------------------------
BEGIN;
INSERT INTO `django_session` VALUES ('a1649be21bd2403adda253f671bb958b', 'NzllMTljNWM3OGJhNzYwODhkNWJlZmJiYmRmY2EwYzlkMzg3ZDU2NTqAAn1xAShVEl9hdXRoX3Vz\nZXJfYmFja2VuZHECVSlkamFuZ28uY29udHJpYi5hdXRoLmJhY2tlbmRzLk1vZGVsQmFja2VuZHED\nVQ1fYXV0aF91c2VyX2lkcQSKAQF1Lg==\n', '2011-10-23 18:20:30');
COMMIT;

-- ----------------------------
-- Table structure for `django_site`
-- ----------------------------
DROP TABLE IF EXISTS `django_site`;
CREATE TABLE `django_site` (
`id`  int(11) NOT NULL AUTO_INCREMENT ,
`domain`  varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ,
`name`  varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ,
PRIMARY KEY (`id`)
)
ENGINE=InnoDB
DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci
AUTO_INCREMENT=2

;

-- ----------------------------
-- Records of django_site
-- ----------------------------
BEGIN;
INSERT INTO `django_site` VALUES ('1', 'example.com', 'example.com');
COMMIT;

-- ----------------------------
-- Table structure for `pp_case_ppcasehandle`
-- ----------------------------
DROP TABLE IF EXISTS `pp_case_ppcasehandle`;
CREATE TABLE `pp_case_ppcasehandle` (
`id`  int(11) NOT NULL AUTO_INCREMENT ,
`caseID_id`  int(11) NOT NULL ,
`handleDate`  date NOT NULL ,
`handleAction`  varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ,
PRIMARY KEY (`id`),
FOREIGN KEY (`caseID_id`) REFERENCES `pp_case_ppcaseinvestigation` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
INDEX `pp_case_ppcasehandle_2cd4a15f` USING BTREE (`caseID_id`) 
)
ENGINE=InnoDB
DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci
AUTO_INCREMENT=1

;

-- ----------------------------
-- Records of pp_case_ppcasehandle
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for `pp_case_ppcaseinfo`
-- ----------------------------
DROP TABLE IF EXISTS `pp_case_ppcaseinfo`;
CREATE TABLE `pp_case_ppcaseinfo` (
`caseID`  varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ,
`orderNo`  varchar(25) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL ,
`paymentAmount`  decimal(9,2) NOT NULL ,
`paymentCurrency`  varchar(3) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ,
`transactionID`  varchar(17) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ,
`caseStartDate`  date NOT NULL ,
`paypalCaseDeclaration`  varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL ,
`paypalCaseStatus`  varchar(8) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL ,
`paypalCaseWindow`  int(11) NULL DEFAULT NULL ,
PRIMARY KEY (`caseID`)
)
ENGINE=InnoDB
DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci

;

-- ----------------------------
-- Records of pp_case_ppcaseinfo
-- ----------------------------
BEGIN;
INSERT INTO `pp_case_ppcaseinfo` VALUES ('PP-001-410-367-333', 'fr-fr_1108050305_73', '72.73', 'EUR', '9991594087712122H', '2011-09-02', '未收到', '补偿请求', '2'), ('PP-001-412-480-596', 'en-uk_1106180436_526', '43.62', 'USD', '12M839177W6780015', '2011-09-08', '', '', '2'), ('PP-001-413-400-363', 'en-uk_1107270423_431', '34.31', 'GBP', '16G4332179831062T', '2011-09-01', '未收到', '', '2'), ('PP-001-419-080-259', 'en-uk_1107140401_301', '103.97', 'USD', '92Y442729N8725419', '2011-09-04', '与描述不相符', '补偿请求', '2'), ('PP-001-420-076-065', 'de-ge_1107072042_556', '27.52', 'EUR', '561245229A752194B', '2011-09-05', '与描述不相符', '关闭', '2'), ('PP-001-420-217-577', 'fr-fr_1107240123_56', '166.41', 'EUR', '91607455CV4953243', '2011-09-05', '与描述不相符', '补偿请求', '2'), ('PP-001-420-461-118', 'en-uk_110805212428_211', '35.96', 'USD', '7FR3809318751413C', '2011-09-05', '未收到', '补偿请求', '2'), ('PP-001-421-779-657', 'en-uk_1107292204_129', '24.97', 'USD', '5MU48435WB531934Y', '2011-09-06', '未收到', '补偿请求', '2'), ('PP-001-422-052-997', 'fr-fr_1107282345_82', '58.32', 'EUR', '605731379D581151M', '2011-09-05', '与描述不相符', '补偿请求', '2'), ('PP-001-423-314-867', 'en-uk_1108020858_12', '168.99', 'USD', '4T288700XM920054C', '2011-09-07', '', '争议', '2'), ('PP-001-425-000-796', 'en-uk_110730215917_925', '77.86', 'AUD', '5AJ84353MK719583B', '2011-09-30', '未收到', '补偿请求', '2'), ('PP-001-425-334-764', 'en-uk_1107201902_827', '62.28', 'GBP', '4EA08412P0804132A', '2011-09-14', '与描述不相符', '补偿请求', '2'), ('PP-001-425-904-046', 'en-uk_1107280809_898', '102.53', 'USD', '74F36903DF924384H', '2011-09-08', '', '争议', '2'), ('PP-001-427-092-048', 'en-uk_110805003547_401', '51.20', 'USD', '81M748683E5975520', '2011-09-01', '未收到', '补偿请求', '2'), ('PP-001-427-179-646', 'de-ge_1108041642_436', '178.29', 'EUR', '0PP66185NM1840940', '2011-09-28', '', '补偿请求', '2'), ('PP-001-427-547-455', 'en-uk_1107280427_964', '38.82', 'USD', '2DA89744H99362358', '2011-09-06', '与描述不相符', '补偿请求', '2'), ('PP-001-427-774-652', 'fr-fr_1107280327_644', '66.27', 'EUR', '5LH0788616858763P', '2011-09-10', '', '争议', '2'), ('PP-001-428-132-562', 'en-uk_1107280908_787', '30.97', 'USD', '0E5501600F668704T', '2011-09-06', '与描述不相符', '补偿请求', '2'), ('PP-001-428-538-197', 'es-sp_1107162254_731', '48.26', 'EUR', '092424507H871151K', '2011-09-07', '与描述不相符', '补偿请求', '2'), ('PP-001-430-118-006', 'en-uk_1108071821_216', '103.56', 'EUR', '2MG51331BN516845M', '2011-09-11', '未收到', '争议', '2'), ('PP-001-430-302-889', 'fr-fr_1108080016_737', '32.41', 'EUR', '26H27852YB854014X', '2011-09-03', '未收到', '补偿请求', '2'), ('PP-001-431-587-034', 'es-sp_110805171437_881', '87.86', 'EUR', '08E13462GX576911S', '2011-09-08', '未收到', '补偿请求', '2'), ('PP-001-431-824-915', 'de-ge_1107252300_225', '71.30', 'EUR', '0A632444D9942262Y', '2011-09-04', '未收到', '补偿请求', '2'), ('PP-001-432-260-854', 'de-ge_110801051842_129', '196.91', 'EUR', '3R4727975Y194014M', '2011-10-06', '与描述不相符', '补偿请求', '2'), ('PP-001-432-571-961', 'en-uk_1108031508_952', '228.94', 'USD', '15X38633PH0400734', '2011-09-02', '未收到', '补偿请求', '2'), ('PP-001-433-565-186', 'en-uk_1107160421_0', '88.32', 'GBP', '5LR193153E225381K', '2011-09-12', '与描述不相符', '补偿请求', '2'), ('PP-001-433-840-662', 'fr-fr_1108081738_910', '208.01', 'EUR', '7UN391724P5198919', '2011-09-02', '未收到', '补偿请求', '2'), ('PP-001-438-493-969', 'en-uk_110730044054_909', '54.98', 'USD', '6JD29718KU915304T', '2011-09-09', '', '', '2'), ('PP-001-439-220-661', 'fr-fr_1108080750_910', '43.20', 'EUR', '1XD742468P3587836', '2011-09-02', '未收到', '补偿请求', '2'), ('PP-001-439-678-313', 'en-uk_1108132204_678', '38.06', 'USD', '9AB08260HV064481M', '2011-10-02', '未收到', '补偿请求', '2'), ('PP-001-439-870-514', 'en-uk_1107202102_106', '246.93', 'USD', '9A6132837L313692Y', '2011-09-03', '与描述不相符', '补偿请求', '2'), ('PP-001-439-947-576', 'en-uk_110812150115_595', '121.92', 'USD', '3YP52824604825947', '2011-09-03', '未收到', '补偿请求', '2'), ('PP-001-440-159-741', 'en-uk_1107292111_620', '52.90', 'USD', '99W457897K472381P', '2011-09-07', '未收到', '补偿请求', '2'), ('PP-001-442-636-218', 'en-uk_1107160715_992', '101.96', 'USD', '98451443UL572514U', '2011-09-18', '未收到', '补偿请求', '2'), ('PP-001-442-644-914', 'de-ge_1108150116_817', '57.57', 'EUR', '482889665B522131H', '2011-09-05', '与描述不相符', '补偿请求', '2'), ('PP-001-442-683-482', 'en-uk_1108060404_804', '306.53', 'USD', '8BH01885YG7978930', '2011-09-01', '未收到', '补偿请求', '2'), ('PP-001-442-750-877', 'de-ge_110801034227_437', '105.11', 'EUR', '2P679838VA2004317', '2011-09-04', '未收到', '补偿请求', '2'), ('PP-001-442-780-759', 'es-sp_110729193941_805', '127.47', 'EUR', '8M636588GR828923U', '2011-09-04', '未收到', '补偿请求', '2'), ('PP-001-443-798-222', 'en-uk_1107241625_46', '509.21', 'AUD', '60R77023434342109', '2011-10-03', '未收到', '补偿请求', '2'), ('PP-001-444-731-223', 'en-uk_1108061311_451', '64.99', 'USD', '2PF5349619791374D', '2011-09-02', '未收到', '补偿请求', '2'), ('PP-001-444-938-504', 'de-ge_1108050251_810', '44.65', 'EUR', '09161611VH348003K', '2011-09-03', '未收到', '补偿请求', '2'), ('PP-001-444-978-863', 'en-uk_1107290926_399', '102.96', 'USD', '27M8570267879702S', '2011-09-03', '与描述不相符', '补偿请求', '2'), ('PP-001-444-989-522', 'fr-fr_1107290259_999', '86.41', 'EUR', '8BG0500454641304U', '2011-10-04', '未收到', '补偿请求', '2'), ('PP-001-445-053-824', 'en-uk_1107201541_255', '96.38', 'USD', '7CW94194YR4119046', '2011-10-03', '', '补偿请求', '2'), ('PP-001-445-792-198', 'de-ge_1107250551_292', '40.31', 'EUR', '8VN51427E0081811F', '2011-10-03', '', '补偿请求', '2'), ('PP-001-446-037-116', 'es-sp_1108010436_866', '35.29', 'EUR', '5C340616XX548521X', '2011-09-03', '未收到', '补偿请求', '2'), ('PP-001-446-138-252', 'de-ge_110805193403_039', '246.78', 'EUR', '92P31838SU546714D', '2011-09-03', '未收到', '补偿请求', '2'), ('PP-001-446-585-097', 'fr-fr_1107230405_180', '31.68', 'EUR', '8CH30078FL027811D', '2011-09-14', '未收到', '补偿请求', '2'), ('PP-001-446-952-833', 'de-ge_110828095301_301', '53.11', 'EUR', '3UN83397BG437874V', '2011-09-12', '', '补偿请求', '2'), ('PP-001-448-522-494', 'en-uk_1108160831_870', '59.99', 'USD', '2GE67674NX637143P', '2011-09-05', '与描述不相符', '补偿请求', '2'), ('PP-001-448-536-486', 'ru-ru_110808040941_279', '87.92', 'USD', '76548797NG484064C', '2011-09-22', '未收到', '补偿请求', '2'), ('PP-001-448-894-289', 'de-ge_1107192229_371', '21.89', 'EUR', '5TV91482JS990501S', '2011-09-19', '未收到', '补偿请求', '2'), ('PP-001-449-043-177', 'es-sp_110806054639_115', '64.65', 'EUR', '6L363390G5635610E', '2011-09-21', '', '争议', '2'), ('PP-001-449-346-983', 'es-sp_110804053832_013', '37.44', 'EUR', '6L4321061G306880N', '2011-09-02', '未收到', '争议', '2'), ('PP-001-450-473-883', 'en-uk_110829064606_019', '25.99', 'USD', '6FU25237UH8103352', '2011-09-02', '未经授权', '补偿请求', '2'), ('PP-001-450-997-618', 'en-uk_1109031548_834', '105.97', 'USD', '3K9390735U173842C', '2011-09-03', 'PayPal查询', '补偿请求', '2'), ('PP-001-452-264-694', 'en-uk_1108250414_826', '117.98', 'USD', '1AV80648NK032543G', '2011-09-17', '未收到', '补偿请求', '2'), ('PP-001-452-949-294', 'de-ge_110801163830_075', '43.22', 'EUR', '1M737877JL994162A', '2011-09-08', '未收到', '争议', '2'), ('PP-001-453-404-308', 'es-sp_110802155443_129', '77.95', 'EUR', '078201885L625710W', '2011-10-01', '未收到', '补偿请求', '2'), ('PP-001-453-459-211', 'fr-fr_1105131646_554', '37.96', 'EUR', '3T705269DH033764T', '2011-09-13', '未收到', '补偿请求', '2'), ('PP-001-453-577-797', 'en-uk_1108061126_676', '67.96', 'USD', '71K35565X6470471W', '2011-09-06', '未收到', '补偿请求', '2'), ('PP-001-453-917-498', 'de-ge_110802022224_129', '75.35', 'EUR', '8239463788666472V', '2011-10-04', '未收到', '补偿请求', '2'), ('PP-001-454-054-318', 'en-uk_1108121206_656', '91.99', 'USD', '5W271912XB4134446', '2011-09-05', '与描述不相符', '补偿请求', '2'), ('PP-001-454-811-139', 'en-uk_1108040825_769', '137.97', 'USD', '3SL34070K10193225', '2011-09-12', '未收到', '补偿请求', '2'), ('PP-001-454-964-077', 'de-ge_1107090523_793', '53.02', 'EUR', '4GD35784FB033441U', '2011-09-06', '未收到', '补偿请求', '2'), ('PP-001-455-113-931', 'en-uk_1108260322_263', '81.46', 'USD', '0AU92074NK9359746', '2011-09-06', 'PayPal查询', '补偿请求', '2'), ('PP-001-455-159-363', 'en-uk_1107211134_726', '108.96', 'USD', '5LY52823UD417593Y', '2011-09-13', '', '补偿请求', '2'), ('PP-001-455-273-346', 'de-ge_110806204139_919', '120.26', 'EUR', '3R646022S4043981T', '2011-09-06', '未收到', '补偿请求', '2'), ('PP-001-455-767-149', 'de-ge_110804164659_043', '40.33', 'EUR', '5RB01977L7557393J', '2011-09-13', '未收到', '补偿请求', '2'), ('PP-001-455-783-864', 'fr-fr_1108041521_815', '94.77', 'EUR', '98065588R67603022', '2011-10-04', '未收到', '补偿请求', '2'), ('PP-001-455-875-546', 'de-ge_1108200308_923', '440.05', 'EUR', '26F1976204047461U', '2011-09-27', '未收到', '争议', '2'), ('PP-001-455-956-321', 'fr-fr_1108050051_6', '58.35', 'EUR', '2BD60942L9067845L', '2011-09-11', '未收到', '争议', '2'), ('PP-001-455-982-739', 'fr-fr_1108060417_666', '68.40', 'EUR', '4JM53687KW428672A', '2011-09-22', '未收到', '补偿请求', '2'), ('PP-001-456-024-491', 'fr-fr_110818002716_483', '145.05', 'EUR', '2SF88558TE8259132', '2011-09-08', '与描述不相符', '争议', '2'), ('PP-001-456-154-495', 'fr-fr_110901060709_019', '73.18', 'EUR', '9RM45675E10701504', '2011-10-04', '未收到', '补偿请求', '2'), ('PP-001-456-258-552', 'fr-fr_1108190340_66', '44.68', 'EUR', '1K13750160901845K', '2011-10-06', '未收到', '补偿请求', '2'), ('PP-001-456-284-251', 'en-uk_110812033936_610', '50.50', 'USD', '11H68490EY1108945', '2011-09-21', '未收到', '补偿请求', '2'), ('PP-001-456-330-773', 'de-ge_1108152257_34', '46.77', 'EUR', '03Y736305S0255718', '2011-10-01', '未收到', '补偿请求', '2'), ('PP-001-456-391-659', 'en-uk_1108062250_255', '389.41', 'USD', '18U6253078131480T', '2011-09-11', '未收到', '补偿请求', '2'), ('PP-001-456-861-173', 'es-sp_1108160448_231', '45.17', 'EUR', '71084749MA393404M', '2011-09-07', '未收到', '争议', '2'), ('PP-001-456-935-919', 'en-uk_1108192358_46', '45.08', 'USD', '2SA45933SV756423G', '2011-09-28', '未收到', '争议', '2'), ('PP-001-457-006-968', 'de-ge_1108221625_211', '63.32', 'EUR', '29N58908JM184922S', '2011-09-28', '未收到', '补偿请求', '2'), ('PP-001-457-087-554', 'fr-fr_1107280445_055', '40.32', 'EUR', '50X42308XY108183R', '2011-09-20', '未收到', '退单', '2'), ('PP-001-457-195-605', 'en-uk_1108022223_788', '145.55', 'GBP', '3YK81682TV197005G', '2011-09-19', '与描述不相符', '补偿请求', '2'), ('PP-001-457-217-243', 'fr-fr_1108142300_898', '41.73', 'EUR', '6RS44009YN081120X', '2011-09-18', '未收到', '补偿请求', '2'), ('PP-001-457-231-517', 'de-ge_110822031911_715', '131.85', 'EUR', '4KG90708YH807423F', '2011-09-18', '与描述不相符', '补偿请求', '2'), ('PP-001-457-243-099', 'de-ge_1109080910_859', '52.52', 'EUR', '5RB393288N192540E', '2011-09-27', '未收到', '补偿请求', '2'), ('PP-001-457-265-267', 'fr-fr_1107292045_244', '23.75', 'EUR', '2NT65397NT350041Y', '2011-10-01', '未收到', '补偿请求', '2'), ('PP-001-457-625-214', 'de-ge_110826204319_971', '43.19', 'EUR', '26A59651D9202630K', '2011-09-12', '未收到', '争议', '2'), ('PP-001-457-936-123', 'en-uk_1109090512_171', '147.18', 'USD', '7AE99708LV557114F', '2011-09-11', '', '补偿请求', '2'), ('PP-001-457-959-289', 'en-uk_1108261135_252', '68.99', 'USD', '1BP23646J7391163T', '2011-09-27', '与描述不相符', '补偿请求', '2'), ('PP-001-457-982-902', 'en-uk_1108160815_514', '83.99', 'USD', '29T50997LW498171T', '2011-09-13', '与描述不相符', '补偿请求', '2'), ('PP-001-457-985-509', 'en-uk_1108160247_958', '56.69', 'USD', '0LT30142DF527741B', '2011-09-28', '未收到', '争议', '2'), ('PP-001-457-993-346', 'en-uk_1108081115_176', '53.97', 'USD', '1M718179P2274024N', '2011-09-08', '未收到', '争议', '2'), ('PP-001-458-080-351', 'en-uk_110803004017_152', '45.98', 'USD', '4PK37614X6483891W', '2011-10-01', '未收到', '补偿请求', '2'), ('PP-001-458-165-169', 'en-uk_1108231342_451', '53.98', 'USD', '2J350757C4391321R', '2011-09-27', '与描述不相符', '补偿请求', '2'), ('PP-001-458-187-857', 'en-uk_1106100151_277', '265.86', 'USD', '91P32946K09357034', '2011-09-21', '未收到', '退单', '2'), ('PP-001-458-291-931', 'it-it_1107121650_420', '172.71', 'EUR', '8WS76008BM661251M', '2011-09-09', '', '', '2'), ('PP-001-458-669-251', 'en-uk_110901114616_141', '110.01', 'USD', '6D131360XL6099847', '2011-09-11', '', '补偿请求', '2'), ('PP-001-459-098-087', 'fr-fr_110815054644_177', '41.09', 'EUR', '4YM35254JS362901X', '2011-09-09', '未收到', '争议', '2');
INSERT INTO `pp_case_ppcaseinfo` VALUES ('PP-001-459-672-923', 'es-sp_1108090756_163', '136.40', 'EUR', '3XS123717K8655248', '2011-09-30', '未收到', '争议', '2');
COMMIT;

-- ----------------------------
-- Table structure for `pp_case_ppcaseinvestigation`
-- ----------------------------
DROP TABLE IF EXISTS `pp_case_ppcaseinvestigation`;
CREATE TABLE `pp_case_ppcaseinvestigation` (
`id`  int(11) NOT NULL AUTO_INCREMENT ,
`orderNo_id`  varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ,
`departmentGroup`  varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL ,
`investigationInfo`  varchar(256) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL ,
`reasonGroup`  varchar(25) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL ,
`involvedProvider`  varchar(25) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL ,
`involvedCategory`  varchar(25) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL ,
PRIMARY KEY (`id`),
FOREIGN KEY (`orderNo_id`) REFERENCES `pp_case_ppcaseinfo` (`caseID`) ON DELETE RESTRICT ON UPDATE RESTRICT,
INDEX `pp_case_ppcaseinvestigation_13e8098a` USING BTREE (`orderNo_id`) 
)
ENGINE=InnoDB
DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci
AUTO_INCREMENT=1

;

-- ----------------------------
-- Records of pp_case_ppcaseinvestigation
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for `pp_case_ppcaserefund`
-- ----------------------------
DROP TABLE IF EXISTS `pp_case_ppcaserefund`;
CREATE TABLE `pp_case_ppcaserefund` (
`id`  int(11) NOT NULL AUTO_INCREMENT ,
`orderNo_id`  varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ,
`refundDate`  date NOT NULL ,
`refundAmount`  decimal(9,2) NOT NULL ,
PRIMARY KEY (`id`),
FOREIGN KEY (`orderNo_id`) REFERENCES `pp_case_ppcaseinfo` (`caseID`) ON DELETE RESTRICT ON UPDATE RESTRICT,
INDEX `pp_case_ppcaserefund_13e8098a` USING BTREE (`orderNo_id`) 
)
ENGINE=InnoDB
DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci
AUTO_INCREMENT=1

;

-- ----------------------------
-- Records of pp_case_ppcaserefund
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Auto increment value for `auth_group`
-- ----------------------------
ALTER TABLE `auth_group` AUTO_INCREMENT=1;

-- ----------------------------
-- Auto increment value for `auth_group_permissions`
-- ----------------------------
ALTER TABLE `auth_group_permissions` AUTO_INCREMENT=1;

-- ----------------------------
-- Auto increment value for `auth_message`
-- ----------------------------
ALTER TABLE `auth_message` AUTO_INCREMENT=1;

-- ----------------------------
-- Auto increment value for `auth_permission`
-- ----------------------------
ALTER TABLE `auth_permission` AUTO_INCREMENT=37;

-- ----------------------------
-- Auto increment value for `auth_user`
-- ----------------------------
ALTER TABLE `auth_user` AUTO_INCREMENT=2;

-- ----------------------------
-- Auto increment value for `auth_user_groups`
-- ----------------------------
ALTER TABLE `auth_user_groups` AUTO_INCREMENT=1;

-- ----------------------------
-- Auto increment value for `auth_user_user_permissions`
-- ----------------------------
ALTER TABLE `auth_user_user_permissions` AUTO_INCREMENT=1;

-- ----------------------------
-- Auto increment value for `django_admin_log`
-- ----------------------------
ALTER TABLE `django_admin_log` AUTO_INCREMENT=1;

-- ----------------------------
-- Auto increment value for `django_content_type`
-- ----------------------------
ALTER TABLE `django_content_type` AUTO_INCREMENT=13;

-- ----------------------------
-- Auto increment value for `django_site`
-- ----------------------------
ALTER TABLE `django_site` AUTO_INCREMENT=2;

-- ----------------------------
-- Auto increment value for `pp_case_ppcasehandle`
-- ----------------------------
ALTER TABLE `pp_case_ppcasehandle` AUTO_INCREMENT=1;

-- ----------------------------
-- Auto increment value for `pp_case_ppcaseinvestigation`
-- ----------------------------
ALTER TABLE `pp_case_ppcaseinvestigation` AUTO_INCREMENT=1;

-- ----------------------------
-- Auto increment value for `pp_case_ppcaserefund`
-- ----------------------------
ALTER TABLE `pp_case_ppcaserefund` AUTO_INCREMENT=1;
